package modele;

import java.sql.*;
import javax.servlet.http.HttpServlet;

public class Connect { //singleton
    private static Connection con=null;
    private static Connection open(){
        try{
            Class.forName("org.postgresql.Driver");
        }catch(ClassNotFoundException e){
            System.out.println("Pilote mal installé ..." + e);
        }
        try{
            con = DriverManager.getConnection("jdbc:postgresql://lucie/medecin", "bbrenner", "linux");
        }catch(SQLException e){
            System.out.println("Erruer SQL :" + e);
        }
        return con;
    }
    public static Connection get(){
        if(con==null){
            con=Connect.open();
        }
        return con;
    }
    public static void close(){
        try{
            con.close();
        }catch(SQLException e){
            System.out.println("Erruer SQL :" + e);
        }
    }
}
